longchar data type??

------=_Part_35322_5317961.1137715626664
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi all. I'm desparately trying to get Microsoft Project to connect to work
with my postgresql server via ODBC. For some reason, MS Project tries to
create a column with the datatype "longchar" when it should be
"longvarchar". Is it possible to tweak the psqlodbc source code so that i=
t
will accept the "longchar" type and convert it to "text" ?? I'd be happy
to write a patch if someone can point me in the right direction...

------=_Part_35322_5317961.1137715626664
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi all.  I'm desparately trying to get Microsoft Project to connect to=
work with my postgresql server via ODBC.  For some reason,  MS P=
roject tries to create a column with the datatype  "longchar"=
;  when it should be "longvarchar".   Is it possib=
le to tweak the psqlodbc source code so that it will accept the "longc=
har" type and convert it to "text" ??   I'd be hap=
py to write a patch if someone can point me in the right direction...



------=_Part_35322_5317961.1137715626664--

Re: longchar data type??

Ben Davis writes:
> Hi all. I'm desparately trying to get Microsoft Project to connect to work
> with my postgresql server via ODBC. For some reason, MS Project tries to
> create a column with the datatype "longchar" when it should be
> "longvarchar". Is it possible to tweak the psqlodbc source code so that it
> will accept the "longchar" type and convert it to "text" ?? I'd be happy
> to write a patch if someone can point me in the right direction...

Seems like it might work to just go

CREATE DOMAIN longchar AS text;


regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: longchar data type??

Thu, Jan 19, 2006 at 07:20:17PM -0500, Tom Lane napsal(a):
> Ben Davis writes:
> > Hi all. I'm desparately trying to get Microsoft Project to connect to work
> > with my postgresql server via ODBC. For some reason, MS Project tries to
> > create a column with the datatype "longchar" when it should be
> > "longvarchar". Is it possible to tweak the psqlodbc source code so that it
> > will accept the "longchar" type and convert it to "text" ?? I'd be happy
> > to write a patch if someone can point me in the right direction...
>
> Seems like it might work to just go
>
> CREATE DOMAIN longchar AS text;

Hello,

it's backend related. We don't support renaming of type, column, table
or something. ODBC doesn't do such statement parsing to know what is what.
And as Tom pointed it would be so easy in PgSQL ;-)

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: longchar data type??

------=_Part_5780_20976110.1137765486232
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Great! I'm all for an easier solution :-)

On 1/19/06, Tom Lane wrote:
>
> Ben Davis writes:
> > Hi all. I'm desparately trying to get Microsoft Project to connect to
> work
> > with my postgresql server via ODBC. For some reason, MS Project tries
> to
> > create a column with the datatype "longchar" when it should be
> > "longvarchar". Is it possible to tweak the psqlodbc source code so
> that it
> > will accept the "longchar" type and convert it to "text" ?? I'd be
> happy
> > to write a patch if someone can point me in the right direction...
>
> Seems like it might work to just go
>
> CREATE DOMAIN longchar AS text;
>
>
> regards, tom lane
>

------=_Part_5780_20976110.1137765486232
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Great!  I'm all for an easier solution :-)